package cn.gson.boot.model.mapper;

import cn.gson.boot.model.pojos.*;
import org.springframework.data.repository.query.Param;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public interface WeiXiuGongDanMapper {

    //根据客户查看联系人
    public List<Contacts> cklianxiren(Integer kId);

    //查看所有部门
    public List<Dept> ckAllBuMen();

    //查看所有维修工单
    List<Weixiugongdan> selectAllWeiXiugd(@Param("kName") String kName,
                                          @Param("gdHao") String gdHao,
                                          @Param("time") String time,
                                          @Param("empName") String empName);

    //根据联系人id查到联系人信息
    public Contacts ckLianXiRenBycId(Integer cId);

    //根据部门id查到部门信息
    public Dept ckBuMenBydeptId(Integer deptId);

    //根据产品id查到产品信息
    public Productt ckCpxx(Integer producttId);

    //根据维修工单id查看维修工单
    public Weixiugongdan selectWeiXiugdByGdId(Integer gdId);



    //查看待检测维修工单
    public List<Weixiugongdan> selectdaiJianCe(@Param("tj") String tj,
                                               @Param("empName")String empName);
    //查看待与客户确认维修工单
    public List<Weixiugongdan> selectdaiYvKeHuQueRen(@Param("tj") String tj,
                                                     @Param("empName")String empName);
    //查看待维修维修工单
    public List<Weixiugongdan> selectdaiWeiXiu(@Param("tj") String tj,
                                               @Param("empName")String empName);
    //查看维修中维修工单
    public List<Weixiugongdan> selectweiXiuZhong(@Param("tj") String tj,
                                                 @Param("empName")String empName);
    //查看修理完成维修工单
    public List<Weixiugongdan> selectxiuLiWanCheng(@Param("tj") String tj,
                                                   @Param("empName")String empName);
    //查看已交付维修工单
    public List<Weixiugongdan> selectyiJiaoFu(@Param("tj") String tj,
                                              @Param("empName")String empName);
    //查看已交付维修工单 未尽收款）
    public List<Weixiugongdan> selectyiJiaoFu22(@Param("tj") String tj,
                                                @Param("empName")String empName);
    //查看已完成维修工单
    public List<Weixiugongdan> selectyiWanCheng(@Param("tj") String tj,
                                                @Param("empName")String empName);
    //查看待交付维修工单
    public List<Weixiugongdan> selectdaiJiaoFu(@Param("tj") String tj,
                                               @Param("empName")String empName);


    //根据工单id查看工单详情
    public List<Wxgdxiangqing> selectgdXQbygdId(Integer gdId);
}
